Common Replenishment Data Fields

The LS Replenishment solution offers different Replenishment calculation types. This topic describes the Replenishment data fields that are common to all Replenishment calculation types.

Other Replenishment data fields that are specific to a Replenishment calculation type will be described in more detail in the corresponding topics.

 

Field Description
Replenishment Calculation Type A Replenishment calculation type can have one of the following values:
  • Average Usage
  • Manual Estimate
  • Stock Levels
  • Like-for-Like
Maximum Inventory If this field is filled in, the system orders the stock up to Maximum Inventory level if the stock on hand gets below the Reorder Point.

Example:

  1. Replenishment Calculation Type is Stock Levels.
    The Maximum Inventory field is 20, the Reorder Point field is set to 10,and the actual inventory is 8. In this case the system will reorder 12.
    If the Maximum Inventory is 0, the system will order according to the Reorder Point and reorders 2.
  1. Replenishment Calculation Type is Average Usage or Manual Estimate.
    The calculated demand due to the historical sales is 30. The Maximum Inventory field is 20 and the Reorder Point field is set to 10 and the actual inventory is 8. The system suggests 30, but the system will only reorder 12 as the inventory cannot be more than 20.
    If the Maximum Inventory is 0, the system will order 22 (Suggested Qty – Inventory).
Replen. Data Profile This field contains the code of the Replen. Data Profile record to be used in the Replenishment calculation process.

For more information see the Replenishment Data Profile.

Vendor No. This field contains the number of the vendor that the item should be purchased from. If the Replenishment Data record found for the item has the Vendor No. field filled in, that vendor will be used. If the field is blank, however, the system first looks at the Stockkeeping Unit record and finally the Item record.

Example:

If the Vendor No. field in the selected Item Store record is blank, the system uses the Vendor No. from the Item record as a Stockkeeping Unit record is not found for the Item No and Location Code.

Purch. Order Delivery This field can have two values, To Warehouse or To Store. The value in this field determines whether the purchase orders are to be delivered to a warehouse or to the stores. It is used by the process that adds items to a Replenishment Journal to select the items for the journal.

The field is used when the function Adding Items to a Purchase Replenishment Journal is executed.

The table shows which conditions must be met if the item is to be selected:

Purchaser Order Type field - Replenishment TemplatePurch. Order Delivery Field - Replenishment Data
One Purchase Order per Vendor
One Purchase Order per Vendor with Cross Docking
To Warehouse
Purchase Orders for Receiving LocationTo Store
Reorder Point If the LS Replenishment system has calculated a demand to replenish an item, the Reorder Point has been filled in, and the suggested quantity is less than the Reorder Point, the system increases the quantity up to the Reorder Point.

Example:

The system suggests reordering 8 pieces and the field Reorder Point is 10, the System Suggested Quantity is changed to 10.

Transfer Multiple Transfer Multiple is used by the process that creates transfer orders from the replenishment journals. If the Transfer Multiple field is filled in for an item, the quantity in the transfer order line for that item is always a multiple of the Transfer Multiple. The system always uses the rounding defined in the Replen. Multiple Rounding page (Departments - LS Retail - Replenishment - Administration).
Purchase Order Multiple Purchase Order Multiple is used by the process that creates the purchase orders from the replenishment journals. If the Order Multiple field is filled in for an item, the Quantity in the purchase order line for that item is always a multiple of the Order Multiple. The system always uses the rounding defined in the Replen. Multiple Rounding page (Departments - LS Retail - Replenishment - Administration).

It is possible to automatically update the Purchase Order Multiple field with Purchase Unit of Measure. Please refer to Using Purchase Unit of Measure for more details.

Exclude from Replenishment If you want to temporarily exclude an item from Replenishment, you can select this field. The replenishment process will not consider this item.